!--[bse_logo_textminingcourse](https://bse.eu/sites/default/files/bse_logo_small.png)-

Text Mining: Models and Algorithms

Problem Set 1

Import Functions

import nltk
nltk.download('wordnet')
nltk.download('stopwords')
nltk.download('punkt')
True
import pandas as pd 
import numpy as np
import matplotlib.pyplot as plt 
import os
import seaborn as sns
import statsmodels.api as sm

# ML Functions
from sklearn.linear_model import LinearRegression
from sklearn.preprocessing import StandardScaler
from sklearn.model_selection import train_test_split, cross_val_score, KFold
from sklearn.metrics import mean_squared_error

# NLP functions
import nltk
from nltk.stem import WordNetLemmatizer
from nltk.stem import PorterStemmer
lemmatizer = WordNetLemmatizer()
from sklearn.feature_extraction.text import CountVectorizer
from sklearn.feature_extraction.text import TfidfVectorizer
from textblob import TextBlob


import spacy
sp = spacy.load('en_core_web_sm')

import re
from nltk.corpus import stopwords

import warnings
# Ignore SettingWithCopyWarning
warnings.filterwarnings("ignore")
warnings.filterwarnings("ignore", category=UserWarning, module="pandas")
warnings.filterwarnings("ignore", category=FutureWarning, module="pandas")

Create DataFrames

barcelona_p1 = pd.DataFrame(pd.read_csv('./Barcelona_Data_06-08.csv'))
barcelona_p2 = pd.DataFrame(pd.read_csv('./Barcelona_Data_13-15_06.csv'))
control_p1 = pd.DataFrame(pd.read_csv('./Valencia_06-08.csv'))
control_p2 = pd.DataFrame(pd.read_csv('./Valencia_13-15.csv'))

Dummy variables

barcelona_p1['Treatment_period'] = 0
barcelona_p2['Treatment_period'] = 1
control_p1['Treatment_period'] = 0
control_p2['Treatment_period'] = 1

barcelona_p1['Treatment_city'] = 1
barcelona_p2['Treatment_city'] = 1
control_p1['Treatment_city'] = 0
control_p2['Treatment_city'] = 0

Concatenate the Dataframes

df = pd.concat([barcelona_p1, barcelona_p2, control_p1, control_p2])

Exploratory Data Analysis

# Create a new column for combined treatment condition
df['Treatment_condition'] = df['Treatment_period'] * 2 + df['Treatment_city']
df['Price'] = pd.to_numeric(df['Price'].str.replace('€', '').str.replace('.', ''), errors='coerce')
mapping = {0: 'Control_city_p1', 1: 'Treatment_city_p1', 2:'Control_city_p2', 3:'Treatment_city_p2'}
df['Treatment_city_and_treatment'] = df['Treatment_condition'].map(mapping)
df = df.drop('Treatment_condition', axis = 1)
df
Unnamed: 0 Hotels Ratings Price Link Descriptions Treatment_period Treatment_city Treatment_city_and_treatment
0 0 Mayerling Bisbe Urquinaona 8,0 443 https://www.booking.com/hotel/es/chic-basic-ur... El Mayerling Bisbe Urquinaona ofrece WiFi grat... 0 1 Treatment_city_p1
1 1 Hotel Arts Barcelona 8,4 1189 https://www.booking.com/hotel/es/arts-barcelon... Este hotel de diseño tiene vistas a la playa d... 0 1 Treatment_city_p1
2 2 Pensión Coral 7,8 194 https://www.booking.com/hotel/es/pensia3n-cora... Esta pensión se encuentra detrás de la plaza d... 0 1 Treatment_city_p1
3 3 Hotel Peninsular 7,0 270 https://www.booking.com/hotel/es/peninsular-ba... Este hotel encantador está situado a pocos min... 0 1 Treatment_city_p1
4 4 H Regas Adults Only 7,5 305 https://www.booking.com/hotel/es/hregas.es.htm... H Regas Adults Only ofrece habitaciones con ai... 0 1 Treatment_city_p1
... ... ... ... ... ... ... ... ... ...
695 695 NH Valencia Las Ciencias 7,6 290 https://www.booking.com/hotel/es/nh-valencia-l... Este hotel goza de una ubicación idónea junto ... 1 0 Control_city_p2
696 696 Sercotel Sorolla Palace 8,3 422 https://www.booking.com/hotel/es/sorolla-palac... El Sorolla Palace ofrece un alojamiento elegan... 1 0 Control_city_p2
697 697 Ilunion Aqua 3 7,8 219 https://www.booking.com/hotel/es/confortel-aqu... El hotel de diseño Ilunion Aqua 3 está situado... 1 0 Control_city_p2
698 698 Hotel Turia 8,1 297 https://www.booking.com/hotel/es/turia.es.html... El Hotel Turia se encuentra junto a la estació... 1 0 Control_city_p2
699 699 One Shot Colón 46 8,1 316 https://www.booking.com/hotel/es/one-shot-colo... El One Shot Colón 46, ubicado a 10 minutos a p... 1 0 Control_city_p2

3200 rows × 9 columns

Plotting Prices with the different Treatment conditions

  • Treated city in treatment Period
  • Control city in Treatment period
  • Treated city in Control Period
  • Control city in Control Period
# Create a boxplot with conditional grouping
plt.figure(figsize=(10, 6))
sns.boxplot(data = df, x ='Treatment_city_and_treatment', y = 'Price')

# Add labels and title
plt.xlabel('Treatment Condition')
plt.ylabel('Prices')
plt.title('Boxplot of Prices by Treatment Condition')

# Show the plot
plt.show()

The plot shows that there is a difference in the distribution of data as the observed prices for the treatment city have a greater standard deviation compared to the values in the control city. It also highlights a difference in the average price in the treatment city in the two different periods which is not matched in the control city, showing that there might be a positive effect of treatment on the prices.

Average Prices

average_prices = df.groupby('Treatment_city_and_treatment')['Price'].mean()
average_prices
Treatment_city_and_treatment
Control_city_p1      253.240000
Control_city_p2      258.440000
Treatment_city_p1    374.038462
Treatment_city_p2    437.423077
Name: Price, dtype: float64

Regressions

Regression based on city

# Regression with only "treatment period" dummy
X1 = sm.add_constant(df['Treatment_city'])
model1 = sm.OLS(df['Price'], X1)
results1 = model1.fit()
print(results1.summary())
                            OLS Regression Results                            
==============================================================================
Dep. Variable:                  Price   R-squared:                       0.135
Model:                            OLS   Adj. R-squared:                  0.135
Method:                 Least Squares   F-statistic:                     499.1
Date:                Wed, 31 Jan 2024   Prob (F-statistic):          7.62e-103
Time:                        17:44:10   Log-Likelihood:                -21196.
No. Observations:                3200   AIC:                         4.240e+04
Df Residuals:                    3198   BIC:                         4.241e+04
Df Model:                           1                                         
Covariance Type:            nonrobust                                         
==================================================================================
                     coef    std err          t      P>|t|      [0.025      0.975]
----------------------------------------------------------------------------------
const            256.1520      5.153     49.709      0.000     246.049     266.255
Treatment_city   147.4659      6.601     22.340      0.000     134.523     160.409
==============================================================================
Omnibus:                     1801.341   Durbin-Watson:                   1.726
Prob(Omnibus):                  0.000   Jarque-Bera (JB):            14393.906
Skew:                           2.615   Prob(JB):                         0.00
Kurtosis:                      11.977   Cond. No.                         2.96
==============================================================================

Notes:
[1] Standard Errors assume that the covariance matrix of the errors is correctly specified.

Interpretation of regression 1

The first regression 1 provides with the average difference in hotel price between Barcelona and Valencia during the period starting from the 13th to the 15th of June 2024. The average difference in hotel price between the 2 cities is 147.5 euros and is significant. This indicates that on average, during that period, average prices in hotels will be 147.5 euros higher in Barcelona than in Valencia. However, it is important to mention that this first regression does not control for other potential confounding factors. Hence, the difference may not necessary originate from the event happening in that period

Regression based on treatment period

# Regression with only "treatment period" dummy
X2 = sm.add_constant(df['Treatment_period'])
model2 = sm.OLS(df['Price'], X2)
results2 = model2.fit()
print(results2.summary())
                            OLS Regression Results                            
==============================================================================
Dep. Variable:                  Price   R-squared:                       0.005
Model:                            OLS   Adj. R-squared:                  0.004
Method:                 Least Squares   F-statistic:                     14.85
Date:                Wed, 31 Jan 2024   Prob (F-statistic):           0.000119
Time:                        18:15:14   Log-Likelihood:                -21343.
No. Observations:                3188   AIC:                         4.269e+04
Df Residuals:                    3186   BIC:                         4.270e+04
Df Model:                           1                                         
Covariance Type:            nonrobust                                         
====================================================================================
                       coef    std err          t      P>|t|      [0.025      0.975]
------------------------------------------------------------------------------------
const              332.8992      4.925     67.597      0.000     323.243     342.555
Treatment_period    26.7051      6.930      3.854      0.000      13.118      40.293
==============================================================================
Omnibus:                     1823.024   Durbin-Watson:                   1.502
Prob(Omnibus):                  0.000   Jarque-Bera (JB):            14272.722
Skew:                           2.681   Prob(JB):                         0.00
Kurtosis:                      11.871   Cond. No.                         2.63
==============================================================================

Notes:
[1] Standard Errors assume that the covariance matrix of the errors is correctly specified.

Interpretation of regression 2

The second regression indicates the average difference in hotel price between the period starting from the 13th to the 15th of June 2024 and the previous period starting from the 6th to the 8th of June 2024. The average difference in hotel price between the 2 periods is 26.7 euros and is significant. In other words, hotel prices during the period going from the 13th to the 15th appear to be higher in both cities in comparison to the previous period.

Regression Based on city and Treatment Period

# Regression with both "treatment period" and "treatment city" dummies and their interaction
df['Interaction_term'] = df['Treatment_period'] * df['Treatment_city']
X3 = sm.add_constant(df[['Treatment_period', 'Treatment_city', 'Interaction_term']])
model3 = sm.OLS(df['Price'], X3)
results3 = model3.fit()
print(results3.summary())
                            OLS Regression Results                            
==============================================================================
Dep. Variable:                  Price   R-squared:                       0.151
Model:                            OLS   Adj. R-squared:                  0.150
Method:                 Least Squares   F-statistic:                     189.4
Date:                Wed, 31 Jan 2024   Prob (F-statistic):          4.83e-113
Time:                        17:44:10   Log-Likelihood:                -21166.
No. Observations:                3200   AIC:                         4.234e+04
Df Residuals:                    3196   BIC:                         4.236e+04
Df Model:                           3                                         
Covariance Type:            nonrobust                                         
====================================================================================
                       coef    std err          t      P>|t|      [0.025      0.975]
------------------------------------------------------------------------------------
const              253.2400      7.699     32.893      0.000     238.145     268.335
Treatment_period     5.2000     10.288      0.505      0.613     -14.972      25.372
Treatment_city     120.7985      9.519     12.690      0.000     102.134     139.463
Interaction_term    58.1846     13.153      4.424      0.000      32.395      83.975
==============================================================================
Omnibus:                     1778.169   Durbin-Watson:                   1.758
Prob(Omnibus):                  0.000   Jarque-Bera (JB):            14105.793
Skew:                           2.574   Prob(JB):                         0.00
Kurtosis:                      11.905   Cond. No.                         7.90
==============================================================================

Notes:
[1] Standard Errors assume that the covariance matrix of the errors is correctly specified.

Interpretation of regression 3

In the third regression, we include an interaction term and both city and period dummy variables. The coefficient 'Interaction Term' represents the difference-in-differences (DiD) estimate.

It captures the differential effect of the treatment on prices by considering the interaction between "treatment period" and "treatment city" and allows us to tell whether the effect of the festival period on hotel prices is significantly different in Barcelona compared to Valencia.. The DiD method helps to control for time-invariant factors and isolates the impact of the treatment by comparing the changes in the treatment city to the changes in the control city over time.

The need for a second city (control city) is crucial in the DiD analysis as it allows us to have counterfactual. The control city accounts for trends or factors affecting both the treatment and control groups similarly. The interaction term (Treatment_period × Treatment_city) captures the differential effect by considering how the treatment effect varies across the treatment and control groups.

Since the results show that there is a high, positive and significant coefficient this shows that there is a substantially positive effect of treatment on prices. In other words, we can conclude that the festival SONORA happening in Barcelona during that period does positively influence hotel prices.

NLP - Analyzing Descriptions

Utils

def abbr_or_lower(word):
    if re.match('([A-Z]+[a-z]*){2,}', word):
        return word
    else:
        return word.lower()
df.shape
(3200, 10)
df = df.dropna()

Preprocessing:

  • Removing special characters and numbers.
  • Converting words to lowercase.
  • Removing stopwords.
  • Applying stemming.
text_column = 'Descriptions'

# Remove special characters and numbers
# df['processed_text'] = df[text_column].apply(lambda x: re.sub(r'[^a-zA-Z\s]', '', x))

# OR (if you want to keep numbers)
df['processed_text'] = df[text_column].apply(lambda x: re.sub(r'\W', ' ', x))

# Convert each word using abbr_or_lower function
df['processed_text'] = df['processed_text'].apply(lambda x: ' '.join(abbr_or_lower(word) for word in x.split()))

# Remove stopwords
stop_words = set(stopwords.words('spanish'))
df['processed_text'] = df['processed_text'].apply(lambda x: ' '.join([word for word in x.split() if word not in stop_words]))

# Apply stemming
stemmer = PorterStemmer()
df['processed_text'] = df['processed_text'].apply(lambda x: ' '.join([stemmer.stem(word) for word in x.split()]))

print(df['processed_text'])
0      mayerl bisb urquinaona ofrec wifi gratuita pre...
1      hotel diseño vista playa barceloneta centro ba...
2      pensión encuentra detrá plaza sant jaum barrio...
3      hotel encantador situado poco minuto pie rambl...
4      h rega adult onli ofrec habitacion air acondic...
                             ...                        
695    hotel goza ubicación idónea junto ciudad art c...
696    sorolla palac ofrec alojamiento elegant ubicad...
697    hotel diseño ilunion aqua 3 situado valencia s...
698    hotel turia encuentra junto estación autobus v...
699    one shot colón 46 ubicado 10 minuto pie catedr...
Name: processed_text, Length: 3188, dtype: object

Creating a document-term matrix (DTM)

# Create document term matrix using CountVectorizer

pd.set_option('display.max_columns', None)
vectorizer = CountVectorizer(ngram_range = (1,2), min_df=0.05, max_df=0.30)
X = vectorizer.fit_transform(df['processed_text'])

# Convert DTM to DataFrame
dtm_df = pd.DataFrame(X.toarray(), columns=vectorizer.get_feature_names_out())
display(dtm_df)
dtm_df.shape
00 10 10 minuto 12 14 14 km 15 15 minuto 20 20 minuto 200 200 metro 22 30 300 300 metro 400 400 metro 50 50 metro 500 500 metro 600 600 metro abierta abierta 24 acondicionado calefacción acondicionado cocina acondicionado suelo acondicionado tv acondicionado wifi aeropuerto barcelona aeropuerto cercano aeropuerto valencia agua air libr alberga alberga restaurant alojamiento air alojamiento alojamiento alojamiento ofrec alojamiento punto alojamiento situado alquil alquil bicicleta alquil coch alrededor amplia antiguo aparcamiento aparcamiento privado apart apartamento aperitivo arena armario art ciencia art santuaria artículo artículo aseo aseo aseo gratuito asimismo autobus autobú avenida avenida diagon bajo bajo petición balcón bar barcelona hotel barcelona prat barceloné bare bare restaurant barrio barrio gótico basílica basílica virgen batlló bañera bañera hidromasaj baño compartido bebida bebida aperitivo bella bicicleta bien bien comunicado buffet cada cada habitación cafetera cafetería café calefacción call cama cama toalla carta casa casa batlló casco casco antiguo catalonia catalunya cataluña catedr catedr barcelona central centro barcelona centro ciudad centro comerci centro fit cerca cerca alojamiento cercana cercano cercano aeropuerto cerámica cerámica art chromecast church church of ciencia ciudad art coch cocina compartida cocina mediterránea cocina totalment color comedor comerci compartida compartido comunica comunicado común conexion conexión conexión wi conexión wifi consigna consigna equipaj cuentan cálido decoración decoración moderna decoración sencilla desamparado desayuno desayuno buffet diagon diario directo diseño dispon disponen air disponen baño distancia distancia pie ducha ducha artículo ducha secador día edificio elegant encuentra barcelona encuentra km encuentra minuto encuentran enlac equipada air equipado equipaj escritorio especial establecimiento alberga establecimiento halla establecimiento ofrec estación tren estilo estrella estrella ofrec expendedora exterior facilita familia familia gaudí famosa fi fi gratuita fit fogon frent fuert minibar fuert tv funcional gaudí gimnasio gimnasio piscina gonzález gonzález martí goza goza ubicación gracia gran grati grati alojamiento gratuita caja gratuita habitacion gratuita toda gratuita tv gratuito gratuito secador gótico habitacion air habitacion disponen habitacion hotel habitacion incluyen habitacion moderna habitacion recepción habitación halla hervidor hervidor agua hidromasaj hora servicio horno hospit hostal hotel encuentra hotel estrella hotel ofrec hotel situado huésped ideal impresionant impresionant ciudad incluy incluyen air incluyen escritorio incluyen tv información información turística inmediacion insonorizada instalacion interé jardin jardin monfort jardín jardín turia junto km aeropuerto km alojamiento lavadora lavavajilla libr lleva lugar lugar interé luminosa madera malvarrosa martí mañana mediterránea meno meno km menú mercado metro estación metro hospit metro hotel metro parada metro plaza microonda microonda cafetera mientra min min pie minibar minibar caja minuto coch minuto metro moderna moderno monfort monumento mostrador mostrador información museo museo nacion máquina máquina expendedora mármol nacion nacion cerámica nevera nicolá nort nou numerosa numerosa tienda numeroso numeroso bare obra of of saint ofrec alojamiento ofrec apartamento ofrec servicio ofrec wifi ofrecen parada parada autobú park park privado parqu part paseo paseo gracia pedrera pelo artículo pequeña person persona petición pie estación pie paseo pie plaza piscina piscina air plana baño plato plato cocina playa playa malvarrosa plaza catalunya plaza cataluña poca poca distancia poco prat presenta presentan presentan decoración presta presta servicio privado ducha privado secador proporciona pued pueden puerto punto punto interé público queda rambla rambla barcelona restaurant bare ropa ropa cama sagrada sagrada familia saint saint nicolá sala salón sant santuaria santuaria gonzález satélit sencilla servicio alquil servicio habitacion sirv desayuno situada solo minuto spa suelo suelo madera suplemento temporada terraza tienda tienda restaurant toalla toda habitacion toda instalacion torr totalment totalment equipada transport transport público tren tren nort turia turística tv vía ubicación ubicado uso uso común valencia km valencia ofrec valencia solo varia vario virgen virgen desamparado vista vista ciudad vía vía satélit wi wi fi wifi grati zona comedor
0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 1 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 2 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 2 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 2 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 2 1 0 1 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 2 1 0 0 0 0 0 0
2 3 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0 0 0 1 0 1 0 0 1 1 1 1 0 0 0 0 0 0 0 1 0 0 0 0 1 1 1 1 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 1 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 1 0 0 0 1 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 1 1 0 0 0 0 0 2 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0
3 0 1 1 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0
4 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 1 2 1 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 1 1 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 1 1 0 1 0 0 0 0 1 1 0 0 0 1 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 1 1 0 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
3183 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 1 0 1 1 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 1 1 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 1 0 0 0 0 0 0 0 0 0 4 1 0 0 0 0 0 0 1 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 2 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0
3184 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 2 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 1 1 0 0 0 0
3185 1 0 0 1 0 0 0 0 1 1 0 0 0 0 1 1 0 0 1 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 2 1 0 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 1 0 1 0 1 1 1 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 2 1 0 0 0 0 0 0 0 0 0 0 1 1 2 0 0 0 1 0 2 0 0 1 0 0 0 0 0 0 0 0 0 1 1 1 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 1 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 2 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 1 0 0 2 0 0 0 0 0 0 1 0 0 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 1 1 1 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 1 0 0 0 0 0 0 1 1 0 0 0 0
3186 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 1 0 0 0 2 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 2 1 0 0 0 1 1 0 0 5 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3187 0 1 1 1 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 1 1 1 1 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 2 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 0 1 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 2 0 1 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 1 0 0 0 0 0 1 1 0 0 0 0 0 0

3188 rows × 422 columns

(3188, 422)

Percentage of presence of chosen word

chosen_word = 'desayuno'
print(f"Percentage of presence of the chose word: {round((dtm_df[chosen_word].sum()/dtm_df.shape[0]),3)*100}%")
Percentage of presence of the chose word: 32.2%

Vizualization

Word Cloud

from wordcloud import WordCloud
import matplotlib.pyplot as plt

# Create a high-resolution word cloud object with relative scaling
wordcloud = WordCloud(
    background_color='white', 
    colormap='Blues', 
    width=800, 
    height=400,
    relative_scaling= 0  # Adjust the relative scaling value as desired
).generate_from_frequencies(dtm_df.sum())

# Plot the word cloud with a higher resolution
plt.figure(figsize=(10, 6), dpi=300)
plt.imshow(wordcloud, interpolation='bilinear')
plt.axis('off')
plt.show()

Creating Term Frequency (TF)-Inverse Document Frequency (IDF) and text_length features

# Create TF-IDF vectorizer
tfidf_vectorizer = TfidfVectorizer(ngram_range=(1, 2), min_df=0.05, max_df=0.30)
X_tfidf = tfidf_vectorizer.fit_transform(df['processed_text'])

# Convert TF-IDF to DataFrame
tfidf_df = pd.DataFrame(X_tfidf.toarray(), columns=tfidf_vectorizer.get_feature_names_out())

# Reset index of the original DataFrame to avoid duplicate indices
df = df.reset_index(drop=True)

# Add length feature
tfidf_df['text_length'] = df['processed_text'].apply(len)

# Concatenate the TF-IDF features and length with your original DataFrame
final_df = pd.concat([df, tfidf_df], axis=1)

# Display the final DataFrame
display(final_df)
Unnamed: 0 Hotels Ratings Price Link Descriptions Treatment_period Treatment_city Treatment_city_and_treatment Interaction_term processed_text 00 10 10 minuto 12 14 14 km 15 15 minuto 20 20 minuto 200 200 metro 22 30 300 300 metro 400 400 metro 50 50 metro 500 500 metro 600 600 metro abierta abierta 24 acondicionado calefacción acondicionado cocina acondicionado suelo acondicionado tv acondicionado wifi aeropuerto barcelona aeropuerto cercano aeropuerto valencia agua air libr alberga alberga restaurant alojamiento air alojamiento alojamiento alojamiento ofrec alojamiento punto alojamiento situado alquil alquil bicicleta alquil coch alrededor amplia antiguo aparcamiento aparcamiento privado apart apartamento aperitivo arena armario art ciencia art santuaria artículo artículo aseo aseo aseo gratuito asimismo autobus autobú avenida avenida diagon bajo bajo petición balcón bar barcelona hotel barcelona prat barceloné bare bare restaurant barrio barrio gótico basílica basílica virgen batlló bañera bañera hidromasaj baño compartido bebida bebida aperitivo bella bicicleta bien bien comunicado buffet cada cada habitación cafetera cafetería café calefacción call cama cama toalla carta casa casa batlló casco casco antiguo catalonia catalunya cataluña catedr catedr barcelona central centro barcelona centro ciudad centro comerci centro fit cerca cerca alojamiento cercana cercano cercano aeropuerto cerámica cerámica art chromecast church church of ciencia ciudad art coch cocina compartida cocina mediterránea cocina totalment color comedor comerci compartida compartido comunica comunicado común conexion conexión conexión wi conexión wifi consigna consigna equipaj cuentan cálido decoración decoración moderna decoración sencilla desamparado desayuno desayuno buffet diagon diario directo diseño dispon disponen air disponen baño distancia distancia pie ducha ducha artículo ducha secador día edificio elegant encuentra barcelona encuentra km encuentra minuto encuentran enlac equipada air equipado equipaj escritorio especial establecimiento alberga establecimiento halla establecimiento ofrec estación tren estilo estrella estrella ofrec expendedora exterior facilita familia familia gaudí famosa fi fi gratuita fit fogon frent fuert minibar fuert tv funcional gaudí gimnasio gimnasio piscina gonzález gonzález martí goza goza ubicación gracia gran grati grati alojamiento gratuita caja gratuita habitacion gratuita toda gratuita tv gratuito gratuito secador gótico habitacion air habitacion disponen habitacion hotel habitacion incluyen habitacion moderna habitacion recepción habitación halla hervidor hervidor agua hidromasaj hora servicio horno hospit hostal hotel encuentra hotel estrella hotel ofrec hotel situado huésped ideal impresionant impresionant ciudad incluy incluyen air incluyen escritorio incluyen tv información información turística inmediacion insonorizada instalacion interé jardin jardin monfort jardín jardín turia junto km aeropuerto km alojamiento lavadora lavavajilla libr lleva lugar lugar interé luminosa madera malvarrosa martí mañana mediterránea meno meno km menú mercado metro estación metro hospit metro hotel metro parada metro plaza microonda microonda cafetera mientra min min pie minibar minibar caja minuto coch minuto metro moderna moderno monfort monumento mostrador mostrador información museo museo nacion máquina máquina expendedora mármol nacion nacion cerámica nevera nicolá nort nou numerosa numerosa tienda numeroso numeroso bare obra of of saint ofrec alojamiento ofrec apartamento ofrec servicio ofrec wifi ofrecen parada parada autobú park park privado parqu part paseo paseo gracia pedrera pelo artículo pequeña person persona petición pie estación pie paseo pie plaza piscina piscina air plana baño plato plato cocina playa playa malvarrosa plaza catalunya plaza cataluña poca poca distancia poco prat presenta presentan presentan decoración presta presta servicio privado ducha privado secador proporciona pued pueden puerto punto punto interé público queda rambla rambla barcelona restaurant bare ropa ropa cama sagrada sagrada familia saint saint nicolá sala salón sant santuaria santuaria gonzález satélit sencilla servicio alquil servicio habitacion sirv desayuno situada solo minuto spa suelo suelo madera suplemento temporada terraza tienda tienda restaurant toalla toda habitacion toda instalacion torr totalment totalment equipada transport transport público tren tren nort turia turística tv vía ubicación ubicado uso uso común valencia km valencia ofrec valencia solo varia vario virgen virgen desamparado vista vista ciudad vía vía satélit wi wi fi wifi grati zona comedor text_length
0 0 Mayerling Bisbe Urquinaona 8,0 443 https://www.booking.com/hotel/es/chic-basic-ur... El Mayerling Bisbe Urquinaona ofrece WiFi grat... 0 1 Treatment_city_p1 0 mayerl bisb urquinaona ofrec wifi gratuita pre... 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.204189 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.164533 0.164533 0.000000 0.000000 0.000000 0.000000 0.188808 0.0 0.000000 0.000000 0.0 0.144280 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.150032 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.143906 0.0 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.14289 0.000000 0.0 0.158418 0.000000 0.0000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.310403 0.000000 0.000000 0.000000 0.151844 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.117135 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.00000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.166358 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.00000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.000000 0.000000 0.000000 0.163576 0.0 0.000000 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.00000 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.170517 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.191962 0.000000 0.0 0.000000 0.00000 0.00000 0.000000 0.00000 0.0 0.000000 0.000000 0.0 0.0 0.00000 0.000000 0.00000 0.0 0.000000 0.0 0.0 0.146389 0.207201 0.000000 0.0 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.000000 0.174864 0.0 0.000000 0.00000 0.0 0.0 0.000000 0.0 0.170517 0.170517 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.183607 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.00000 0.0 0.310403 0.000000 0.000000 0.000000 0.000000 0.182431 0.000000 0.000000 0.0 0.0 0.0 0.180156 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.152279 0.133756 0.201063 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.274018 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 450
1 1 Hotel Arts Barcelona 8,4 1189 https://www.booking.com/hotel/es/arts-barcelon... Este hotel de diseño tiene vistas a la playa d... 0 1 Treatment_city_p1 0 hotel diseño vista playa barceloneta centro ba... 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.142039 0.142039 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.130649 0.225842 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.107559 0.0 0.000000 0.0 0.233039 0.149891 0.000000 0.000000 0.0 0.0 0.000000 0.144183 0.000000 0.000000 0.000000 0.00000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.000000 0.0 0.000000 0.000000 0.0000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.132504 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.179741 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.170011 0.000000 0.000000 0.000000 0.000000 0.0 0.105991 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.0 0.169163 0.0 0.000000 0.000000 0.171755 0.0 0.0 0.0 0.0 0.316385 0.000000 0.000000 0.00000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.00000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.000000 0.000000 0.111341 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.00000 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.162345 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.264819 0.0 0.0 0.0 0.000000 0.118921 0.0 0.000000 0.00000 0.00000 0.000000 0.00000 0.0 0.000000 0.158358 0.0 0.0 0.00000 0.000000 0.00000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.00000 0.0 0.0 0.144551 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.146305 0.000000 0.0 0.000000 0.0 0.000000 0.233980 0.145295 0.000000 0.139546 0.0 0.214789 0.00000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.164192 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.158193 0.000000 0.000000 0.000000 0.0 0.000000 0.119559 0.0 0.000000 0.000000 0.000000 0.0 0.147208 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.176674 0.141460 0.0 0.0 0.209155 0.139436 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 717
2 2 Pensión Coral 7,8 194 https://www.booking.com/hotel/es/pensia3n-cora... Esta pensión se encuentra detrás de la plaza d... 0 1 Treatment_city_p1 0 pensión encuentra detrá plaza sant jaum barrio... 0.393361 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.268752 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.133441 0.139033 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.129108 0.0 0.0 0.0 0.121652 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.115845 0.000000 0.119731 0.000000 0.0 0.079908 0.081537 0.081537 0.087178 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.120614 0.000000 0.0 0.000000 0.0 0.088374 0.113685 0.083641 0.126441 0.0 0.0 0.000000 0.000000 0.000000 0.136125 0.114426 0.00000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.000000 0.0 0.000000 0.127827 0.0000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.120871 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.118507 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.077526 0.000000 0.133073 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.120871 0.118268 0.0 0.000000 0.0 0.0 0.000000 0.124819 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.080754 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.133626 0.00000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.113790 0.000000 0.00000 0.077600 0.000000 0.126441 0.000000 0.256286 0.000000 0.000000 0.00000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.00000 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.093440 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.103105 0.11379 0.00000 0.000000 0.00000 0.0 0.000000 0.000000 0.0 0.0 0.00000 0.000000 0.00000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.100714 0.0 0.133626 0.133626 0.000000 0.0 0.0 0.101666 0.0 0.0 0.0 0.0 0.0 0.108897 0.125694 0.000000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.00000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.112959 0.0 0.000000 0.000000 0.0 0.092859 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.00000 0.0 0.000000 0.128622 0.128622 0.000000 0.000000 0.000000 0.094391 0.102114 0.0 0.0 0.0 0.000000 0.0 0.235116 0.000000 0.000000 0.000000 0.000000 0.000000 0.100786 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.099438 0.0 0.0 0.000000 0.117209 0.0 0.000000 0.000000 0.000000 0.122451 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.098885 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.107291 0.0 0.0 0.079317 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 726
3 3 Hotel Peninsular 7,0 270 https://www.booking.com/hotel/es/peninsular-ba... Este hotel encantador está situado a pocos min... 0 1 Treatment_city_p1 0 hotel encantador situado poco minuto pie rambl... 0.000000 0.115346 0.125098 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.153848 0.158676 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.152552 0.152552 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.119979 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.167905 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.123802 0.000000 0.117171 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.154243 0.0 0.000000 0.000000 0.0000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.143899 0.149574 0.187717 0.158676 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.111776 0.168967 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.113991 0.148858 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.182727 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.00000 0.000000 0.0 0.0 0.0 0.168967 0.168967 0.000000 0.0 0.000000 0.0 0.000000 0.186421 0.0 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.00000 0.000000 0.000000 0.000000 0.000000 0.000000 0.152043 0.000000 0.00000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.00000 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.119979 0.126279 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.140686 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.00000 0.00000 0.000000 0.00000 0.0 0.000000 0.000000 0.0 0.0 0.00000 0.182964 0.00000 0.0 0.179736 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.152552 0.176083 0.000000 0.0 0.0 0.000000 0.0 0.137954 0.000000 0.0 0.119197 0.00000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.155450 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.00000 0.0 0.143899 0.000000 0.000000 0.178416 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.248032 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.193571 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.126279 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.168967 0.168967 0.000000 0.0 602
4 4 H Regas Adults Only 7,5 305 https://www.booking.com/hotel/es/hregas.es.htm... H Regas Adults Only ofrece habitaciones con ai... 0 1 Treatment_city_p1 0 h rega adult onli ofrec habitacion air acondic... 0.000000 0.000000 0.000000 0.000000 0.142058 0.164615 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.120725 0.0 0.113062 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.153251 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.094611 0.096539 0.096539 0.103219 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.0 0.118989 0.0 0.000000 0.000000 0.099030 0.000000 0.0 0.0 0.119416 0.258954 0.161886 0.000000 0.000000 0.00000 0.0 0.0 0.000000 0.000000 0.000000 0.132664 0.161172 0.00000 0.000000 0.0 0.000000 0.000000 0.1027 0.124334 0.000000 0.119416 0.119416 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.107364 0.153251 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.096342 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.0 0.151909 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.142058 0.157993 0.000000 0.00000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.130363 0.000000 0.108733 0.0 0.0 0.000000 0.000000 0.00000 0.091878 0.140742 0.000000 0.113284 0.000000 0.000000 0.000000 0.00000 0.161408 0.153642 0.000000 0.000000 0.0 0.161886 0.0 0.0 0.0 0.402328 0.0 0.0 0.0 0.0 0.00000 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.110632 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.00000 0.00000 0.000000 0.00000 0.0 0.000000 0.000000 0.0 0.0 0.00000 0.000000 0.00000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.116596 0.000000 0.0 0.000000 0.00000 0.0 0.0 0.000000 0.0 0.133622 0.133622 0.126928 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.00000 0.0 0.000000 0.000000 0.000000 0.000000 0.118989 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.143417 0.153251 0.000000 0.000000 0.000000 0.000000 0.0 0.105118 0.108206 0.0 0.0 0.0 0.0 0.0 0.0 0.117734 0.0 0.0 0.000000 0.000000 0.0 0.130926 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.111545 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.108733 0.0 462
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
3183 695 NH Valencia Las Ciencias 7,6 290 https://www.booking.com/hotel/es/nh-valencia-l... Este hotel goza de una ubicación idónea junto ... 1 0 Control_city_p2 0 hotel goza ubicación idónea junto ciudad art c... 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.104868 0.110967 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.147621 0.151943 0.000000 0.127339 0.0 0.101827 0.103902 0.103902 0.000000 0.0 0.152733 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.145813 0.17717 0.0 0.0 0.000000 0.000000 0.124549 0.142782 0.000000 0.00000 0.280611 0.0 0.000000 0.000000 0.0000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.133402 0.145002 0.000000 0.115553 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.509355 0.127339 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.133713 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.101675 0.000000 0.127429 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.195894 0.124549 0.0 0.0 0.0 0.000000 0.103690 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.00000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.0 0.172212 0.172212 0.000000 0.156211 0.000000 0.0 0.0 0.000000 0.000000 0.15924 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.00000 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.127973 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.00000 0.00000 0.000000 0.00000 0.0 0.163293 0.000000 0.0 0.0 0.00000 0.000000 0.00000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.0 0.000000 0.106471 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.00000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.143944 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.103796 0.00000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.109618 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.145136 0.000000 0.0 0.0 0.0 0.167529 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 543
3184 696 Sercotel Sorolla Palace 8,3 422 https://www.booking.com/hotel/es/sorolla-palac... El Sorolla Palace ofrece un alojamiento elegan... 1 0 Control_city_p2 0 sorolla palac ofrec alojamiento elegant ubicad... 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.195593 0.195593 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.151497 0.0 0.000000 0.0 0.000000 0.0 0.147229 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.148473 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.162481 0.203150 0.000000 0.000000 0.00000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.163592 0.0 0.000000 0.000000 0.0000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.148473 0.148473 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.115187 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.120899 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.142814 0.0 0.0 0.188543 0.000000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.19772 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.169696 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.182137 0.000000 0.0 0.0 0.169068 0.000000 0.00000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.000000 0.000000 0.000000 0.000000 0.0 0.203150 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.00000 0.0 0.195854 0.195854 0.0 0.187419 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.134012 0.0 0.000000 0.00000 0.18946 0.000000 0.00000 0.0 0.000000 0.000000 0.0 0.0 0.00000 0.000000 0.00000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.148683 0.0 0.000000 0.000000 0.0 0.126421 0.00000 0.0 0.0 0.162895 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.137969 0.0 0.000000 0.263672 0.163733 0.000000 0.157255 0.0 0.000000 0.00000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.119202 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.122591 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.146923 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.117848 0.000000 0.119202 0.119202 0.000000 0.000000 0.000000 0.0 643
3185 697 Ilunion Aqua 3 7,8 219 https://www.booking.com/hotel/es/confortel-aqu... El hotel de diseño Ilunion Aqua 3 está situado... 1 0 Control_city_p2 0 hotel diseño ilunion aqua 3 situado valencia s... 0.116759 0.000000 0.000000 0.109039 0.000000 0.000000 0.000000 0.000000 0.096646 0.099598 0.000000 0.000000 0.000000 0.000000 0.095930 0.095930 0.0 0.0 0.117224 0.117224 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.118661 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.152528 0.122669 0.0 0.0 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.099071 0.0 0.081977 0.0 0.0 0.000000 0.000000 0.106177 0.000000 0.088983 0.0 0.071156 0.072606 0.072606 0.077630 0.0 0.000000 0.084812 0.0 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.000000 0.0 0.000000 0.000000 0.0000 0.000000 0.107177 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.093221 0.202653 0.098984 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.088983 0.088983 0.156761 0.0 0.000000 0.0 0.123422 0.0 0.186875 0.0 0.000000 0.119489 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.121393 0.069034 0.112191 0.000000 0.0 0.068445 0.000000 0.0 0.0 0.0 0.114822 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.071909 0.123422 0.115999 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.00000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.098984 0.0 0.000000 0.0 0.115112 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.00000 0.069101 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.10989 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.21368 0.0 0.000000 0.000000 0.0 0.000000 0.116605 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.00000 0.00000 0.100314 0.10684 0.0 0.114108 0.000000 0.0 0.0 0.23476 0.000000 0.00000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.203028 0.0 0.172666 0.074401 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.122116 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.075767 0.10077 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.100587 0.0 0.000000 0.239315 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.094172 0.000000 0.0 0.145064 0.10684 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.0 0.000000 0.117068 0.000000 0.000000 0.000000 0.000000 0.089747 0.000000 0.000000 0.0 0.079058 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.071441 0.000000 0.0 0.000000 0.076600 0.000000 0.109039 0.106840 0.090862 0.107404 0.000000 0.0 0.000000 0.080747 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.079985 0.000000 0.088054 0.0 0.0 0.0 0.000000 0.121933 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.071441 0.071441 0.000000 0.000000 0.000000 0.0 1019
3186 698 Hotel Turia 8,1 297 https://www.booking.com/hotel/es/turia.es.html... El Hotel Turia se encuentra junto a la estació... 1 0 Control_city_p2 0 hotel turia encuentra junto estación autobus v... 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.113646 0.117118 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.106767 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.135190 0.0 0.0 0.0 0.000000 0.000000 0.0 0.096398 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.104636 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.125503 0.000000 0.0 0.0 0.0 0.0 0.126297 0.085422 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.0 0.0 0.107881 0.141106 0.000000 0.000000 0.000000 0.00000 0.000000 0.0 0.000000 0.000000 0.0000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.111801 0.000000 0.000000 0.000000 0.000000 0.119150 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.104636 0.104636 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.109874 0.0 0.000000 0.000000 0.141106 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.111266 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.113646 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.00000 0.144687 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.285076 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.101998 0.00000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.116092 0.00000 0.000000 0.000000 0.088425 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.00000 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.089680 0.094389 0.000000 0.0 0.099474 0.000000 0.0 0.0 0.214481 0.118174 0.105157 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.00000 0.00000 0.000000 0.00000 0.0 0.000000 0.000000 0.0 0.0 0.00000 0.000000 0.09815 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.120267 0.120267 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.145583 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.00000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.00000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.124854 0.0 0.123096 0.000000 0.000000 0.000000 0.000000 0.133685 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.103687 0.0 0.000000 0.000000 0.0 0.000000 0.180149 0.111622 0.0 0.000000 0.0 0.133685 0.133685 0.0 0.0 0.553687 0.094389 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 683
3187 699 One Shot Colón 46 8,1 316 https://www.booking.com/hotel/es/one-shot-colo... El One Shot Colón 46, ubicado a 10 minutos a p... 1 0 Control_city_p2 0 one shot colón 46 ubicado 10 minuto pie catedr... 0.000000 0.108490 0.117662 0.161343 0.000000 0.000000 0.108433 0.114739 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.160291 0.160291 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.125904 0.0 0.000000 0.112847 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.157760 0.131668 0.0 0.105289 0.107434 0.107434 0.114868 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.158924 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.000000 0.0 0.000000 0.000000 0.0000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.140684 0.000000 0.149245 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.131668 0.131668 0.231957 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.105132 0.000000 0.131761 0.0 0.0 0.127576 0.000000 0.102149 0.166009 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.0 0.169053 0.0 0.106403 0.000000 0.171643 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.00000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.128348 0.00000 0.102247 0.156626 0.000000 0.126069 0.000000 0.000000 0.000000 0.00000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.00000 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.112847 0.118773 0.000000 0.0 0.125172 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.00000 0.00000 0.000000 0.00000 0.0 0.000000 0.000000 0.0 0.0 0.00000 0.172089 0.00000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.173686 0.0 0.0 0.0 0.0 0.300419 0.0 0.127746 0.000000 0.0 0.0 0.151337 0.151337 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.00000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.00000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.113344 0.140458 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.118773 0.000000 0.000000 0.130293 0.0 0.0 0.0 0.173224 0.000000 0.000000 0.000000 0.0 0.0 0.104509 0.139345 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 522

3188 rows × 434 columns

Show top words

from nltk.corpus import stopwords

# Assuming 'Descriptions' is the column containing text descriptions
corpus = df['Descriptions']

# Create TF-IDF vectorizer
tfidf_vectorizer = TfidfVectorizer(max_features=1000, stop_words=stopwords.words("spanish"))
X_tfidf = tfidf_vectorizer.fit_transform(corpus)

# Get feature names and TF-IDF scores
feature_names = tfidf_vectorizer.get_feature_names_out()
tfidf_scores = X_tfidf.toarray()

# Create a DataFrame to display the top words and their TF-IDF scores
tfidf_df = pd.DataFrame(tfidf_scores, columns=feature_names)

# Display the top words and their TF-IDF scores
top_words = tfidf_df.sum(axis=0).sort_values(ascending=False)
print(top_words)
km             223.598490
hotel          221.109988
alojamiento    197.784737
valencia       192.577596
barcelona      188.507891
                  ...    
sky              4.188302
repleta          4.188302
hetero           4.188302
rocafort         4.188302
gayxample        4.188302
Length: 1000, dtype: float64

Sentiment Analysis

# Assuming 'Descriptions' is the column containing text descriptions
final_df['sentiment'] = final_df['Descriptions'].apply(lambda x: TextBlob(x).sentiment.polarity)
final_df
Unnamed: 0 Hotels Ratings Price Link Descriptions Treatment_period Treatment_city Treatment_city_and_treatment Interaction_term processed_text 00 10 10 minuto 12 14 14 km 15 15 minuto 20 20 minuto 200 200 metro 22 30 300 300 metro 400 400 metro 50 50 metro 500 500 metro 600 600 metro abierta abierta 24 acondicionado calefacción acondicionado cocina acondicionado suelo acondicionado tv acondicionado wifi aeropuerto barcelona aeropuerto cercano aeropuerto valencia agua air libr alberga alberga restaurant alojamiento air alojamiento alojamiento alojamiento ofrec alojamiento punto alojamiento situado alquil alquil bicicleta alquil coch alrededor amplia antiguo aparcamiento aparcamiento privado apart apartamento aperitivo arena armario art ciencia art santuaria artículo artículo aseo aseo aseo gratuito asimismo autobus autobú avenida avenida diagon bajo bajo petición balcón bar barcelona hotel barcelona prat barceloné bare bare restaurant barrio barrio gótico basílica basílica virgen batlló bañera bañera hidromasaj baño compartido bebida bebida aperitivo bella bicicleta bien bien comunicado buffet cada cada habitación cafetera cafetería café calefacción call cama cama toalla carta casa casa batlló casco casco antiguo catalonia catalunya cataluña catedr catedr barcelona central centro barcelona centro ciudad centro comerci centro fit cerca cerca alojamiento cercana cercano cercano aeropuerto cerámica cerámica art chromecast church church of ciencia ciudad art coch cocina compartida cocina mediterránea cocina totalment color comedor comerci compartida compartido comunica comunicado común conexion conexión conexión wi conexión wifi consigna consigna equipaj cuentan cálido decoración decoración moderna decoración sencilla desamparado desayuno desayuno buffet diagon diario directo diseño dispon disponen air disponen baño distancia distancia pie ducha ducha artículo ducha secador día edificio elegant encuentra barcelona encuentra km encuentra minuto encuentran enlac equipada air equipado equipaj escritorio especial establecimiento alberga establecimiento halla establecimiento ofrec estación tren estilo estrella estrella ofrec expendedora exterior facilita familia familia gaudí famosa fi fi gratuita fit fogon frent fuert minibar fuert tv funcional gaudí gimnasio gimnasio piscina gonzález gonzález martí goza goza ubicación gracia gran grati grati alojamiento gratuita caja gratuita habitacion gratuita toda gratuita tv gratuito gratuito secador gótico habitacion air habitacion disponen habitacion hotel habitacion incluyen habitacion moderna habitacion recepción habitación halla hervidor hervidor agua hidromasaj hora servicio horno hospit hostal hotel encuentra hotel estrella hotel ofrec hotel situado huésped ideal impresionant impresionant ciudad incluy incluyen air incluyen escritorio incluyen tv información información turística inmediacion insonorizada instalacion interé jardin jardin monfort jardín jardín turia junto km aeropuerto km alojamiento lavadora lavavajilla libr lleva lugar lugar interé luminosa madera malvarrosa martí mañana mediterránea meno meno km menú mercado metro estación metro hospit metro hotel metro parada metro plaza microonda microonda cafetera mientra min min pie minibar minibar caja minuto coch minuto metro moderna moderno monfort monumento mostrador mostrador información museo museo nacion máquina máquina expendedora mármol nacion nacion cerámica nevera nicolá nort nou numerosa numerosa tienda numeroso numeroso bare obra of of saint ofrec alojamiento ofrec apartamento ofrec servicio ofrec wifi ofrecen parada parada autobú park park privado parqu part paseo paseo gracia pedrera pelo artículo pequeña person persona petición pie estación pie paseo pie plaza piscina piscina air plana baño plato plato cocina playa playa malvarrosa plaza catalunya plaza cataluña poca poca distancia poco prat presenta presentan presentan decoración presta presta servicio privado ducha privado secador proporciona pued pueden puerto punto punto interé público queda rambla rambla barcelona restaurant bare ropa ropa cama sagrada sagrada familia saint saint nicolá sala salón sant santuaria santuaria gonzález satélit sencilla servicio alquil servicio habitacion sirv desayuno situada solo minuto spa suelo suelo madera suplemento temporada terraza tienda tienda restaurant toalla toda habitacion toda instalacion torr totalment totalment equipada transport transport público tren tren nort turia turística tv vía ubicación ubicado uso uso común valencia km valencia ofrec valencia solo varia vario virgen virgen desamparado vista vista ciudad vía vía satélit wi wi fi wifi grati zona comedor text_length sentiment
0 0 Mayerling Bisbe Urquinaona 8,0 443 https://www.booking.com/hotel/es/chic-basic-ur... El Mayerling Bisbe Urquinaona ofrece WiFi grat... 0 1 Treatment_city_p1 0 mayerl bisb urquinaona ofrec wifi gratuita pre... 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.204189 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.164533 0.164533 0.000000 0.000000 0.000000 0.000000 0.188808 0.0 0.000000 0.000000 0.0 0.144280 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.150032 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.143906 0.0 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.14289 0.000000 0.0 0.158418 0.000000 0.0000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.310403 0.000000 0.000000 0.000000 0.151844 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.117135 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.00000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.166358 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.00000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.000000 0.000000 0.000000 0.163576 0.0 0.000000 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.00000 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.170517 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.191962 0.000000 0.0 0.000000 0.00000 0.00000 0.000000 0.00000 0.0 0.000000 0.000000 0.0 0.0 0.00000 0.000000 0.00000 0.0 0.000000 0.0 0.0 0.146389 0.207201 0.000000 0.0 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.000000 0.174864 0.0 0.000000 0.00000 0.0 0.0 0.000000 0.0 0.170517 0.170517 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.183607 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.00000 0.0 0.310403 0.000000 0.000000 0.000000 0.000000 0.182431 0.000000 0.000000 0.0 0.0 0.0 0.180156 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.152279 0.133756 0.201063 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.274018 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 450 0.0
1 1 Hotel Arts Barcelona 8,4 1189 https://www.booking.com/hotel/es/arts-barcelon... Este hotel de diseño tiene vistas a la playa d... 0 1 Treatment_city_p1 0 hotel diseño vista playa barceloneta centro ba... 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.142039 0.142039 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.130649 0.225842 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.107559 0.0 0.000000 0.0 0.233039 0.149891 0.000000 0.000000 0.0 0.0 0.000000 0.144183 0.000000 0.000000 0.000000 0.00000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.000000 0.0 0.000000 0.000000 0.0000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.132504 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.179741 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.170011 0.000000 0.000000 0.000000 0.000000 0.0 0.105991 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.0 0.169163 0.0 0.000000 0.000000 0.171755 0.0 0.0 0.0 0.0 0.316385 0.000000 0.000000 0.00000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.00000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.000000 0.000000 0.111341 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.00000 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.162345 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.264819 0.0 0.0 0.0 0.000000 0.118921 0.0 0.000000 0.00000 0.00000 0.000000 0.00000 0.0 0.000000 0.158358 0.0 0.0 0.00000 0.000000 0.00000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.00000 0.0 0.0 0.144551 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.146305 0.000000 0.0 0.000000 0.0 0.000000 0.233980 0.145295 0.000000 0.139546 0.0 0.214789 0.00000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.164192 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.158193 0.000000 0.000000 0.000000 0.0 0.000000 0.119559 0.0 0.000000 0.000000 0.000000 0.0 0.147208 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.176674 0.141460 0.0 0.0 0.209155 0.139436 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 717 0.0
2 2 Pensión Coral 7,8 194 https://www.booking.com/hotel/es/pensia3n-cora... Esta pensión se encuentra detrás de la plaza d... 0 1 Treatment_city_p1 0 pensión encuentra detrá plaza sant jaum barrio... 0.393361 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.268752 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.133441 0.139033 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.129108 0.0 0.0 0.0 0.121652 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.115845 0.000000 0.119731 0.000000 0.0 0.079908 0.081537 0.081537 0.087178 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.120614 0.000000 0.0 0.000000 0.0 0.088374 0.113685 0.083641 0.126441 0.0 0.0 0.000000 0.000000 0.000000 0.136125 0.114426 0.00000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.000000 0.0 0.000000 0.127827 0.0000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.120871 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.118507 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.077526 0.000000 0.133073 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.120871 0.118268 0.0 0.000000 0.0 0.0 0.000000 0.124819 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.080754 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.133626 0.00000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.113790 0.000000 0.00000 0.077600 0.000000 0.126441 0.000000 0.256286 0.000000 0.000000 0.00000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.00000 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.093440 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.103105 0.11379 0.00000 0.000000 0.00000 0.0 0.000000 0.000000 0.0 0.0 0.00000 0.000000 0.00000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.100714 0.0 0.133626 0.133626 0.000000 0.0 0.0 0.101666 0.0 0.0 0.0 0.0 0.0 0.108897 0.125694 0.000000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.00000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.112959 0.0 0.000000 0.000000 0.0 0.092859 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.00000 0.0 0.000000 0.128622 0.128622 0.000000 0.000000 0.000000 0.094391 0.102114 0.0 0.0 0.0 0.000000 0.0 0.235116 0.000000 0.000000 0.000000 0.000000 0.000000 0.100786 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.099438 0.0 0.0 0.000000 0.117209 0.0 0.000000 0.000000 0.000000 0.122451 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.098885 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.107291 0.0 0.0 0.079317 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 726 0.1
3 3 Hotel Peninsular 7,0 270 https://www.booking.com/hotel/es/peninsular-ba... Este hotel encantador está situado a pocos min... 0 1 Treatment_city_p1 0 hotel encantador situado poco minuto pie rambl... 0.000000 0.115346 0.125098 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.153848 0.158676 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.152552 0.152552 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.119979 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.167905 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.123802 0.000000 0.117171 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.154243 0.0 0.000000 0.000000 0.0000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.143899 0.149574 0.187717 0.158676 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.111776 0.168967 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.113991 0.148858 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.182727 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.00000 0.000000 0.0 0.0 0.0 0.168967 0.168967 0.000000 0.0 0.000000 0.0 0.000000 0.186421 0.0 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.00000 0.000000 0.000000 0.000000 0.000000 0.000000 0.152043 0.000000 0.00000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.00000 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.119979 0.126279 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.140686 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.00000 0.00000 0.000000 0.00000 0.0 0.000000 0.000000 0.0 0.0 0.00000 0.182964 0.00000 0.0 0.179736 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.152552 0.176083 0.000000 0.0 0.0 0.000000 0.0 0.137954 0.000000 0.0 0.119197 0.00000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.155450 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.00000 0.0 0.143899 0.000000 0.000000 0.178416 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.248032 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.193571 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.126279 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.168967 0.168967 0.000000 0.0 602 0.0
4 4 H Regas Adults Only 7,5 305 https://www.booking.com/hotel/es/hregas.es.htm... H Regas Adults Only ofrece habitaciones con ai... 0 1 Treatment_city_p1 0 h rega adult onli ofrec habitacion air acondic... 0.000000 0.000000 0.000000 0.000000 0.142058 0.164615 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.120725 0.0 0.113062 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.153251 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.094611 0.096539 0.096539 0.103219 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.0 0.118989 0.0 0.000000 0.000000 0.099030 0.000000 0.0 0.0 0.119416 0.258954 0.161886 0.000000 0.000000 0.00000 0.0 0.0 0.000000 0.000000 0.000000 0.132664 0.161172 0.00000 0.000000 0.0 0.000000 0.000000 0.1027 0.124334 0.000000 0.119416 0.119416 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.107364 0.153251 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.096342 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.0 0.151909 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.142058 0.157993 0.000000 0.00000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.130363 0.000000 0.108733 0.0 0.0 0.000000 0.000000 0.00000 0.091878 0.140742 0.000000 0.113284 0.000000 0.000000 0.000000 0.00000 0.161408 0.153642 0.000000 0.000000 0.0 0.161886 0.0 0.0 0.0 0.402328 0.0 0.0 0.0 0.0 0.00000 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.110632 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.00000 0.00000 0.000000 0.00000 0.0 0.000000 0.000000 0.0 0.0 0.00000 0.000000 0.00000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.116596 0.000000 0.0 0.000000 0.00000 0.0 0.0 0.000000 0.0 0.133622 0.133622 0.126928 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.00000 0.0 0.000000 0.000000 0.000000 0.000000 0.118989 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.143417 0.153251 0.000000 0.000000 0.000000 0.000000 0.0 0.105118 0.108206 0.0 0.0 0.0 0.0 0.0 0.0 0.117734 0.0 0.0 0.000000 0.000000 0.0 0.130926 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.111545 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.108733 0.0 462 0.0
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
3183 695 NH Valencia Las Ciencias 7,6 290 https://www.booking.com/hotel/es/nh-valencia-l... Este hotel goza de una ubicación idónea junto ... 1 0 Control_city_p2 0 hotel goza ubicación idónea junto ciudad art c... 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.104868 0.110967 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.147621 0.151943 0.000000 0.127339 0.0 0.101827 0.103902 0.103902 0.000000 0.0 0.152733 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.145813 0.17717 0.0 0.0 0.000000 0.000000 0.124549 0.142782 0.000000 0.00000 0.280611 0.0 0.000000 0.000000 0.0000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.133402 0.145002 0.000000 0.115553 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.509355 0.127339 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.133713 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.101675 0.000000 0.127429 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.195894 0.124549 0.0 0.0 0.0 0.000000 0.103690 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.00000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.0 0.172212 0.172212 0.000000 0.156211 0.000000 0.0 0.0 0.000000 0.000000 0.15924 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.00000 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.127973 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.00000 0.00000 0.000000 0.00000 0.0 0.163293 0.000000 0.0 0.0 0.00000 0.000000 0.00000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.0 0.000000 0.106471 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.00000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.143944 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.103796 0.00000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.109618 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.145136 0.000000 0.0 0.0 0.0 0.167529 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 543 0.0
3184 696 Sercotel Sorolla Palace 8,3 422 https://www.booking.com/hotel/es/sorolla-palac... El Sorolla Palace ofrece un alojamiento elegan... 1 0 Control_city_p2 0 sorolla palac ofrec alojamiento elegant ubicad... 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.195593 0.195593 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.151497 0.0 0.000000 0.0 0.000000 0.0 0.147229 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.148473 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.162481 0.203150 0.000000 0.000000 0.00000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.163592 0.0 0.000000 0.000000 0.0000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.148473 0.148473 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.115187 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.120899 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.142814 0.0 0.0 0.188543 0.000000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.19772 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.169696 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.182137 0.000000 0.0 0.0 0.169068 0.000000 0.00000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.000000 0.000000 0.000000 0.000000 0.0 0.203150 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.00000 0.0 0.195854 0.195854 0.0 0.187419 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.134012 0.0 0.000000 0.00000 0.18946 0.000000 0.00000 0.0 0.000000 0.000000 0.0 0.0 0.00000 0.000000 0.00000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.148683 0.0 0.000000 0.000000 0.0 0.126421 0.00000 0.0 0.0 0.162895 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.137969 0.0 0.000000 0.263672 0.163733 0.000000 0.157255 0.0 0.000000 0.00000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.119202 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.122591 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.146923 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.117848 0.000000 0.119202 0.119202 0.000000 0.000000 0.000000 0.0 643 0.0
3185 697 Ilunion Aqua 3 7,8 219 https://www.booking.com/hotel/es/confortel-aqu... El hotel de diseño Ilunion Aqua 3 está situado... 1 0 Control_city_p2 0 hotel diseño ilunion aqua 3 situado valencia s... 0.116759 0.000000 0.000000 0.109039 0.000000 0.000000 0.000000 0.000000 0.096646 0.099598 0.000000 0.000000 0.000000 0.000000 0.095930 0.095930 0.0 0.0 0.117224 0.117224 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.118661 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.152528 0.122669 0.0 0.0 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.099071 0.0 0.081977 0.0 0.0 0.000000 0.000000 0.106177 0.000000 0.088983 0.0 0.071156 0.072606 0.072606 0.077630 0.0 0.000000 0.084812 0.0 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.000000 0.0 0.000000 0.000000 0.0000 0.000000 0.107177 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.093221 0.202653 0.098984 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.088983 0.088983 0.156761 0.0 0.000000 0.0 0.123422 0.0 0.186875 0.0 0.000000 0.119489 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.121393 0.069034 0.112191 0.000000 0.0 0.068445 0.000000 0.0 0.0 0.0 0.114822 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.071909 0.123422 0.115999 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.00000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.098984 0.0 0.000000 0.0 0.115112 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.00000 0.069101 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.10989 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.21368 0.0 0.000000 0.000000 0.0 0.000000 0.116605 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.00000 0.00000 0.100314 0.10684 0.0 0.114108 0.000000 0.0 0.0 0.23476 0.000000 0.00000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.203028 0.0 0.172666 0.074401 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.122116 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.075767 0.10077 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.100587 0.0 0.000000 0.239315 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.094172 0.000000 0.0 0.145064 0.10684 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.0 0.000000 0.117068 0.000000 0.000000 0.000000 0.000000 0.089747 0.000000 0.000000 0.0 0.079058 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.071441 0.000000 0.0 0.000000 0.076600 0.000000 0.109039 0.106840 0.090862 0.107404 0.000000 0.0 0.000000 0.080747 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.079985 0.000000 0.088054 0.0 0.0 0.0 0.000000 0.121933 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.071441 0.071441 0.000000 0.000000 0.000000 0.0 1019 0.0
3186 698 Hotel Turia 8,1 297 https://www.booking.com/hotel/es/turia.es.html... El Hotel Turia se encuentra junto a la estació... 1 0 Control_city_p2 0 hotel turia encuentra junto estación autobus v... 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.113646 0.117118 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.106767 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.135190 0.0 0.0 0.0 0.000000 0.000000 0.0 0.096398 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.104636 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.125503 0.000000 0.0 0.0 0.0 0.0 0.126297 0.085422 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.0 0.0 0.107881 0.141106 0.000000 0.000000 0.000000 0.00000 0.000000 0.0 0.000000 0.000000 0.0000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.111801 0.000000 0.000000 0.000000 0.000000 0.119150 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.104636 0.104636 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.109874 0.0 0.000000 0.000000 0.141106 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.111266 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.113646 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.00000 0.144687 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.285076 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.101998 0.00000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.116092 0.00000 0.000000 0.000000 0.088425 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.00000 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.089680 0.094389 0.000000 0.0 0.099474 0.000000 0.0 0.0 0.214481 0.118174 0.105157 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.00000 0.00000 0.000000 0.00000 0.0 0.000000 0.000000 0.0 0.0 0.00000 0.000000 0.09815 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.120267 0.120267 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.145583 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.00000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.00000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.124854 0.0 0.123096 0.000000 0.000000 0.000000 0.000000 0.133685 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.103687 0.0 0.000000 0.000000 0.0 0.000000 0.180149 0.111622 0.0 0.000000 0.0 0.133685 0.133685 0.0 0.0 0.553687 0.094389 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 683 0.0
3187 699 One Shot Colón 46 8,1 316 https://www.booking.com/hotel/es/one-shot-colo... El One Shot Colón 46, ubicado a 10 minutos a p... 1 0 Control_city_p2 0 one shot colón 46 ubicado 10 minuto pie catedr... 0.000000 0.108490 0.117662 0.161343 0.000000 0.000000 0.108433 0.114739 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.160291 0.160291 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.125904 0.0 0.000000 0.112847 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.157760 0.131668 0.0 0.105289 0.107434 0.107434 0.114868 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.158924 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.00000 0.000000 0.0 0.000000 0.000000 0.0000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.000000 0.140684 0.000000 0.149245 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.131668 0.131668 0.231957 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.105132 0.000000 0.131761 0.0 0.0 0.127576 0.000000 0.102149 0.166009 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.0 0.169053 0.0 0.106403 0.000000 0.171643 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.00000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.128348 0.00000 0.102247 0.156626 0.000000 0.126069 0.000000 0.000000 0.000000 0.00000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.0 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.00000 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.112847 0.118773 0.000000 0.0 0.125172 0.000000 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.00000 0.00000 0.000000 0.00000 0.0 0.000000 0.000000 0.0 0.0 0.00000 0.172089 0.00000 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.173686 0.0 0.0 0.0 0.0 0.300419 0.0 0.127746 0.000000 0.0 0.0 0.151337 0.151337 0.000000 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.0 0.0 0.0 0.0 0.000000 0.000000 0.000000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.00000 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.00000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.0 0.0 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.0 0.0 0.0 0.0 0.000000 0.0 0.0 0.000000 0.000000 0.0 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 0.000000 0.000000 0.0 0.000000 0.113344 0.140458 0.0 0.000000 0.0 0.000000 0.000000 0.0 0.0 0.000000 0.118773 0.000000 0.000000 0.130293 0.0 0.0 0.0 0.173224 0.000000 0.000000 0.000000 0.0 0.0 0.104509 0.139345 0.000000 0.000000 0.000000 0.000000 0.000000 0.0 522 0.0

3188 rows × 435 columns

# Select columns for correlation matrix
# Replace 'Word1', 'Word2', etc., with the actual column names of word frequencies
# and any other columns you want to include
selected_columns = ['Price','Interaction_term', 'Treatment_period', 'Treatment_city', 'Treatment_city_and_treatment', 'desayuno', 'playa', 'balcón', 'acondicionado wifi','dispon','aseo','decoración','barrio','15','10','gratuito']
correlation_df = final_df[selected_columns]

# Compute the correlation matrix
corr_matrix = correlation_df.corr()

# Visualize the correlation matrix
plt.figure(figsize=(10, 8))
sns.heatmap(corr_matrix, annot=True, cmap='Blues')
plt.title('Correlation Matrix')
plt.show()

Ideas for NLP:

  • Including Keyword presence (words related to Sonar Festival)
  • Word Embeddings (Optional)

Final Regression

Adding NLP Features

# Regression with both "treatment period" and "treatment city" dummies and their interaction
final_df['Interaction_term'] = final_df['Treatment_period'] * final_df['Treatment_city']
X4 = sm.add_constant(final_df[['Treatment_period', 'Treatment_city', 'Interaction_term', 'desayuno', 'playa', 'balcón', 'acondicionado wifi', 'bañera hidromasaj','dispon','desayuno','aseo','decoración','tren','barrio','15','10','gratuito']])
model4 = sm.OLS(final_df['Price'], X4)
results4 = model4.fit()
print(results4.summary())
                            OLS Regression Results                            
==============================================================================
Dep. Variable:                  Price   R-squared:                       0.364
Model:                            OLS   Adj. R-squared:                  0.361
Method:                 Least Squares   F-statistic:                     113.6
Date:                Wed, 31 Jan 2024   Prob (F-statistic):          4.10e-297
Time:                        17:44:15   Log-Likelihood:                -20628.
No. Observations:                3188   AIC:                         4.129e+04
Df Residuals:                    3171   BIC:                         4.139e+04
Df Model:                          16                                         
Covariance Type:            nonrobust                                         
======================================================================================
                         coef    std err          t      P>|t|      [0.025      0.975]
--------------------------------------------------------------------------------------
const                247.9079      9.023     27.475      0.000     230.217     265.599
Treatment_period     -16.1378      9.323     -1.731      0.084     -34.418       2.142
Treatment_city       138.1590      9.263     14.915      0.000     119.996     156.322
Interaction_term      74.4520     12.147      6.129      0.000      50.635      98.269
desayuno             198.6024     30.395      6.534      0.000     139.006     258.199
playa                672.9996     43.015     15.646      0.000     588.659     757.340
balcón               396.2481     76.362      5.189      0.000     246.523     545.973
acondicionado wifi  1024.4929     73.507     13.937      0.000     880.366    1168.620
bañera hidromasaj    913.0521     85.363     10.696      0.000     745.680    1080.424
dispon              -344.3062     59.599     -5.777      0.000    -461.162    -227.450
desayuno             198.6024     30.395      6.534      0.000     139.006     258.199
aseo                 322.9083     96.442      3.348      0.001     133.814     512.003
decoración          -845.6676     67.038    -12.615      0.000    -977.109    -714.226
tren                 102.2326     64.172      1.593      0.111     -23.591     228.056
barrio              -140.7429     57.818     -2.434      0.015    -254.107     -27.379
15                    -9.4622     62.903     -0.150      0.880    -132.798     113.873
10                  -316.4583     53.914     -5.870      0.000    -422.168    -210.748
gratuito            -934.4227     99.258     -9.414      0.000   -1129.039    -739.807
==============================================================================
Omnibus:                     1171.244   Durbin-Watson:                   1.695
Prob(Omnibus):                  0.000   Jarque-Bera (JB):             5183.142
Skew:                           1.741   Prob(JB):                         0.00
Kurtosis:                       8.186   Cond. No.                     1.14e+15
==============================================================================

Notes:
[1] Standard Errors assume that the covariance matrix of the errors is correctly specified.
[2] The smallest eigenvalue is 4.62e-27. This might indicate that there are
strong multicollinearity problems or that the design matrix is singular.

Interpretation of regression 4

In our fourth and final regression model, we incorporated set of terms from the document term matrix that are correlated with hotel pricing. This analysis is enriched by the inclusion of both city and time period dummy variables, which serve to adjust for consistent effects over time, as well as an interaction term to understand the combined influences. Essentially, this regression points out how certain descriptive words in hotel listings are associated with pricing - whether they contribute to a price increase or decrease.

The analysis reveals some intriguing findings:

  • The term "acondicionado wifi" appears to have a significant impact, being associated with an increase in hotel pricing by approximately 1024.4929 euros. This could suggest that including air conditioning and WiFi as amenities in the description is a strong indicator of higher-priced accommodations.

  • Similarly, the presence of "bañera hidromasaj" ("whirlpool bath") in the hotel description correlates with a price increase of about 913.0521 euros, indicating that this luxury amenity is a significant value-add in terms of pricing.

  • On the other hand, the word "dispon" (shorthand for "disponibilidad,", i.e. "availability") seems to correlate with a price reduction of -344.3062 euros. This could imply that hotels tend to lower their prices when emphasizing availability, possibly in response to lower demand or higher room availability.

  • Interestingly, the word "decoración" (decoration) is linked with a decrease of 845.6676 euros in hotel pricing. This might suggest that hotels focusing on their aesthetic or decorative aspects could be perceived as more budget-friendly or that they might be emphasizing style over more substantive amenities.

  • The term "gratuito" (meaning "free") also shows a negative correlation, with a reduction of 934.4227 euros in pricing. This could indicate that hotels highlighting free services or amenities might be positioned in a more economical pricing segment.

Assembling the 4 regressions

# REGRESSION1
# Regression with only "treatment period" dummy
X1 = sm.add_constant(df['Treatment_city'])
model1 = sm.OLS(df['Price'], X1)
results1 = model1.fit()

# REGRESSION2
# Regression with only "treatment period" dummy
X2 = sm.add_constant(df['Treatment_period'])
model2 = sm.OLS(df['Price'], X2)
results2 = model2.fit()

#REGRESSION3
# Regression with both "treatment period" and "treatment city" dummies and their interaction
df['Interaction_term'] = df['Treatment_period'] * df['Treatment_city']
X3 = sm.add_constant(df[['Treatment_period', 'Treatment_city', 'Interaction_term']])
model3 = sm.OLS(df['Price'], X3)
results3 = model3.fit()

# REGRESSION4
# Creating the interaction term
final_df['Interaction_term'] = final_df['Treatment_period'] * final_df['Treatment_city']
# Define independent variables (X)
X4 = sm.add_constant(final_df[['Treatment_period', 'Treatment_city', 'Interaction_term', 'desayuno', 'playa', 'balcón', 'acondicionado wifi', 'bañera hidromasaj', 'dispon', 'aseo', 'decoración', 'tren', 'barrio', '15', '10', 'gratuito']])
# Create and fit the model
model4 = sm.OLS(final_df['Price'], X4).fit()

# Create Stargazer object
stargazer = Stargazer([results1, results2, results3, model4])

# Optionally, customize the Stargazer object
stargazer.title("Regression Results")
stargazer.custom_columns(['Model 1', 'Model 2', 'Model 3', 'Model 4'], [1, 1, 1, 1])
stargazer.show_model_numbers(False)
# You can add more customization as needed

# Render the LaTeX table
print(stargazer.render_latex())
\begin{table}[!htbp] \centering
  \caption{Regression Results}
\begin{tabular}{@{\extracolsep{5pt}}lcccc}
\\[-1.8ex]\hline
\hline \\[-1.8ex]
& \multicolumn{4}{c}{\textit{Dependent variable: Price}} \
\cr \cline{2-5}
\\[-1.8ex] & \multicolumn{1}{c}{Model 1} & \multicolumn{1}{c}{Model 2} & \multicolumn{1}{c}{Model 3} & \multicolumn{1}{c}{Model 4}  \\
\hline \\[-1.8ex]
 10 & & & & -316.458$^{***}$ \\
& & & & (53.914) \\
 15 & & & & -9.462$^{}$ \\
& & & & (62.903) \\
 Interaction_term & & & 58.004$^{***}$ & 74.452$^{***}$ \\
& & & (13.217) & (12.147) \\
 Treatment_city & 147.552$^{***}$ & & 120.979$^{***}$ & 138.159$^{***}$ \\
& (6.628) & & (9.597) & (9.263) \\
 Treatment_period & & 26.705$^{***}$ & 5.197$^{}$ & -16.138$^{*}$ \\
& & (6.930) & (10.360) & (9.323) \\
 acondicionado wifi & & & & 1024.493$^{***}$ \\
& & & & (73.507) \\
 aseo & & & & 322.908$^{***}$ \\
& & & & (96.442) \\
 balcón & & & & 396.248$^{***}$ \\
& & & & (76.362) \\
 barrio & & & & -140.743$^{**}$ \\
& & & & (57.818) \\
 bañera hidromasaj & & & & 913.052$^{***}$ \\
& & & & (85.363) \\
 const & 256.179$^{***}$ & 332.899$^{***}$ & 253.243$^{***}$ & 247.908$^{***}$ \\
& (5.182) & (4.925) & (7.787) & (9.023) \\
 decoración & & & & -845.668$^{***}$ \\
& & & & (67.038) \\
 desayuno & & & & 397.205$^{***}$ \\
& & & & (60.791) \\
 dispon & & & & -344.306$^{***}$ \\
& & & & (59.599) \\
 gratuito & & & & -934.423$^{***}$ \\
& & & & (99.258) \\
 playa & & & & 673.000$^{***}$ \\
& & & & (43.015) \\
 tren & & & & 102.233$^{}$ \\
& & & & (64.172) \\
\hline \\[-1.8ex]
 Observations & 3188 & 3188 & 3188 & 3188 \\
 $R^2$ & 0.135 & 0.005 & 0.151 & 0.364 \\
 Adjusted $R^2$ & 0.134 & 0.004 & 0.150 & 0.361 \\
 Residual Std. Error & 182.411 (df=3186) & 195.631 (df=3186) & 180.785 (df=3184) & 156.701 (df=3171) \\
 F Statistic & 495.627$^{***}$ (df=1; 3186) & 14.850$^{***}$ (df=1; 3186) & 188.039$^{***}$ (df=3; 3184) & 113.613$^{***}$ (df=16; 3171) \\
\hline
\hline \\[-1.8ex]
\textit{Note:} & \multicolumn{4}{r}{$^{*}$p$<$0.1; $^{**}$p$<$0.05; $^{***}$p$<$0.01} \\
\end{tabular}
\end{table}